171. Account Statements (Sales Ledger) - Database Profiles Datafile Software Account Statements (Sales Ledger) - Database Profiles Data Item Type Alternative Notes Last Statement date D E Date when a statement was last printed for this account, only applicable if statement set to update the date. State... Read More
172. Account Invoicing (Sales Ledger) - Database Profiles Datafile Software Account Invoicing (Sales Ledger) - Database Profiles Data Item Type Alternative Notes Inv Cost: First Y(6) N, Y(5–8) First record number of an invoice costing record for this account. Inv Cost: Last Y(6) N, Y(5–8) Last reco... Read More
173. Account Currency - Database Profiles Datafile Software Account Currency - Database Profiles Data Item Type Alternative Notes Currency Code X(3) The three-character currency code Curr Bal-bf L K This, and the following, values mirror in the foreign currency the base currency values ... Read More
174. Account Currency Turnover - Database Profiles Datafile Software Account Currency Turnover - Database Profiles Data Item Type Alternative Notes Curr T/O for year L K These values mirror in the foreign currency the base currency values Curr T/O for period L K Curr T/O per 1–13 L K Curr T/O... Read More
175. Trans Mandatory - Database Profiles Datafile Software Trans Mandatory - Database Profiles Data Item Type Alternative Notes Transaction type Y(1) X(1) Holds the type of the transaction record.: 1 Invoice transaction 2 Payment transaction 3 Credit note transaction 4 Invoice ad... Read More
176. Trans Optional 1 - Database Profiles Datafile Software Trans Optional 1 - Database Profiles Data Item Type Alternative Notes Nominal code X (10) Y Only used in type 6–9 analysis records, plus types2 and 5 payments Nominal updated ?-type Nominal ledger changes this to Y as it post... Read More
177. Trans Optional 2 - Database Profiles Datafile Software Trans Optional 2 - Database Profiles Data Item Type Alternative Notes Job Reference X (10) Y Purchase Ledger Only. This item used to hold the job code if ledger linked to job costing. Job Code Analysis X (10) Y Purchase Ledger ... Read More
178. Trans Optional 3 - Database Profiles Datafile Software Trans Optional 3 - Database Profiles Data Item Type Alternative Notes EC Country X (3) Copied from accounts file; needed for EC reports EC Tax Reg X (15) Copied from accounts file; needed for EC reports EC Acquis Tax L K Purch... Read More
179. Trans Cash Tax - Database Profiles Datafile Software Trans Cash Tax - Database Profiles Used for cash accounting purposes, where tax is payable only when invoices are paid. All three must be present in your files for this feature to function. Data Item Type Alternative Notes Tax ... Read More
180. Trans Currency - Database Profiles Datafile Software Trans Currency - Database Profiles Required for foreign currency operation, values mirror the same transaction items as for the base currency, except they hold the foreign currency values. Data Item Type Alternative Notes Curr ... Read More